Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	922733
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	91.5 MiB
Average record size in memory	104.0 B

Variable types

DateTime	1
Numeric	12

Alerts

`heart_rate` is highly correlated with `enhanced_speed` and 1 other fields	High correlation
`enhanced_speed` is highly correlated with `heart_rate` and 1 other fields	High correlation
`cadence` is highly correlated with `heart_rate` and 1 other fields	High correlation
`slope_steep` is highly correlated with `slope_ascent`	High correlation
`slope_ascent` is highly correlated with `slope_steep`	High correlation
`slope_descent` is highly correlated with `slope_steep`	High correlation
`enhanced_altitude` is highly correlated with `temp` and 1 other fields	High correlation
`temp` is highly correlated with `enhanced_altitude` and 2 other fields	High correlation
`wind_speed` is highly correlated with `enhanced_altitude` and 2 other fields	High correlation
`wind_direct` is highly correlated with `temp` and 1 other fields	High correlation
`timestamp` has unique values	Unique
`rain` has 527342 (57.2%) zeros	Zeros
`slope_steep` has 537702 (58.3%) zeros	Zeros
`slope_ascent` has 725108 (78.6%) zeros	Zeros
`slope_descent` has 734893 (79.6%) zeros	Zeros

Reproduction

Analysis started	2023-01-17 19:51:42.563050
Analysis finished	2023-01-17 19:52:54.229734
Duration	1 minute and 11.67 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

timestamp
Date

UNIQUE

Distinct	922733
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	7.0 MiB

Minimum	2022-01-16 06:53:40
Maximum	2023-01-16 15:25:45

Histogram

Histogram with fixed size bins (bins=50)

heart_rate
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	137
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	143.4291577

Minimum	58
Maximum	196
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	58
5-th percentile	119
Q1	131
median	139
Q3	154
95-th percentile	178
Maximum	196
Range	138
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	18.23099457
Coefficient of variation (CV)	0.1271080083
Kurtosis	-0.1126923096
Mean	143.4291577
Median Absolute Deviation (MAD)	10
Skewness	0.4606228711
Sum	132346817
Variance	332.3691629
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
137	30648	3.3%
134	29830	3.2%
136	29605	3.2%
139	28313	3.1%
133	28178	3.1%
138	28137	3.0%
135	27762	3.0%
140	27727	3.0%
131	27418	3.0%
132	26882	2.9%
Other values (127)	638233	69.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
58	1	< 0.1%
60	2	< 0.1%
62	3	< 0.1%
63	5	< 0.1%
64	2	< 0.1%
65	5	< 0.1%
66	3	< 0.1%
67	6	< 0.1%
68	8	< 0.1%
69	6	< 0.1%

Value	Count	Frequency (%)
196	1	< 0.1%
195	3	< 0.1%
194	11	< 0.1%
193	25	< 0.1%
192	90	< 0.1%
191	146	< 0.1%
190	590	0.1%
189	1048	0.1%
188	1518	0.2%
187	1249	0.1%

enhanced_speed
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	4601
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.95800197

Minimum	3.006
Maximum	37.3536
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	3.006
5-th percentile	7.3224
Q1	10.4796
median	11.4228
Q3	12.7296
95-th percentile	17.9712
Maximum	37.3536
Range	34.3476
Interquartile range (IQR)	2.25

Descriptive statistics

Standard deviation	3.151807431
Coefficient of variation (CV)	0.2635730818
Kurtosis	1.618754781
Mean	11.95800197
Median Absolute Deviation (MAD)	1.0728
Skewness	0.5641809857
Sum	11034043.03
Variance	9.933890082
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11.556	9304	1.0%
11.1528	9156	1.0%
11.2536	9136	1.0%
11.3544	8906	1.0%
11.4552	8885	1.0%
11.052	8480	0.9%
11.6568	8376	0.9%
10.9512	7860	0.9%
11.286	7842	0.8%
11.3868	7832	0.8%
Other values (4591)	836956	90.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.006	4	< 0.1%
3.0132	1	< 0.1%
3.024	143	< 0.1%
3.0276	4	< 0.1%
3.0312	1	< 0.1%
3.0348	4	< 0.1%
3.0564	113	< 0.1%
3.06	3	< 0.1%
3.0672	2	< 0.1%
3.0708	4	< 0.1%

Value	Count	Frequency (%)
37.3536	1	< 0.1%
33.5916	1	< 0.1%
30.8376	1	< 0.1%
30.6	4	< 0.1%
30.2328	1	< 0.1%
30.1968	2	< 0.1%
30.1644	2	< 0.1%
30.132	1	< 0.1%
30.0312	1	< 0.1%
29.7288	2	< 0.1%

distance
Real number (ℝ_≥0)

Distinct	706817
Distinct (%)	76.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7163.378849

Minimum	0
Maximum	26408.58
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0
5-th percentile	543.606
Q1	2891.13
median	6304.52
Q3	10460.55
95-th percentile	17046.194
Maximum	26408.58
Range	26408.58
Interquartile range (IQR)	7569.42

Descriptive statistics

Standard deviation	5161.984783
Coefficient of variation (CV)	0.7206075362
Kurtosis	-0.08478775201
Mean	7163.378849
Median Absolute Deviation (MAD)	3698.63
Skewness	0.7228941544
Sum	6609886056
Variance	26646086.91
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3616.46	8	< 0.1%
8804.99	7	< 0.1%
62.69	7	< 0.1%
305.18	7	< 0.1%
797.42	7	< 0.1%
1926.26	7	< 0.1%
6706.09	7	< 0.1%
1472.7	7	< 0.1%
567.91	7	< 0.1%
2343.84	6	< 0.1%
Other values (706807)	922663	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
0.49	1	< 0.1%
0.51	1	< 0.1%
0.67	1	< 0.1%
0.87	1	< 0.1%
0.94	1	< 0.1%
1.08	2	< 0.1%
1.15	1	< 0.1%
1.19	1	< 0.1%
1.25	1	< 0.1%

Value	Count	Frequency (%)
26408.58	1	< 0.1%
26402.76	1	< 0.1%
26389.24	1	< 0.1%
26371.51	1	< 0.1%
26363.73	1	< 0.1%
26361.95	1	< 0.1%
26360.59	2	< 0.1%
26353.62	1	< 0.1%
26348.24	1	< 0.1%
26347.24	1	< 0.1%

enhanced_altitude
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	8278
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	315.5884289

Minimum	129.4
Maximum	2438.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	129.4
5-th percentile	187.8
Q1	197.4
median	242.2
Q3	380
95-th percentile	617.8
Maximum	2438.2
Range	2308.8
Interquartile range (IQR)	182.6

Descriptive statistics

Standard deviation	212.1510517
Coefficient of variation (CV)	0.6722396396
Kurtosis	20.19028679
Mean	315.5884289
Median Absolute Deviation (MAD)	48.6
Skewness	3.908724197
Sum	291203857.8
Variance	45008.06875
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
376.6	17401	1.9%
197.2	6639	0.7%
197.6	6506	0.7%
197.4	6169	0.7%
196.8	5824	0.6%
197.8	5698	0.6%
198	5691	0.6%
197	5595	0.6%
196.6	5552	0.6%
198.6	5419	0.6%
Other values (8268)	852239	92.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
129.4	5	< 0.1%
129.6	1	< 0.1%
129.8	9	< 0.1%
130	26	< 0.1%
130.2	20	< 0.1%
130.4	14	< 0.1%
130.6	14	< 0.1%
130.8	14	< 0.1%
131	51	< 0.1%
131.2	26	< 0.1%

Value	Count	Frequency (%)
2438.2	1	< 0.1%
2438	1	< 0.1%
2437.4	1	< 0.1%
2433.4	1	< 0.1%
2432.8	1	< 0.1%
2431	1	< 0.1%
2430.6	1	< 0.1%
2429.8	1	< 0.1%
2429.2	1	< 0.1%
2428.2	1	< 0.1%

cadence
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	97
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	85.79426335

Minimum	31
Maximum	128
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	31
5-th percentile	81
Q1	85
median	86
Q3	88
95-th percentile	93
Maximum	128
Range	97
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	6.989776517
Coefficient of variation (CV)	0.08147137401
Kurtosis	15.48179407
Mean	85.79426335
Median Absolute Deviation (MAD)	2
Skewness	-3.404833143
Sum	79165198
Variance	48.85697576
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
86	171552	18.6%
87	148312	16.1%
85	129400	14.0%
84	82883	9.0%
88	75997	8.2%
91	49041	5.3%
90	41090	4.5%
83	39877	4.3%
89	39126	4.2%
92	29322	3.2%
Other values (87)	116133	12.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
31	5	< 0.1%
32	11	< 0.1%
33	14	< 0.1%
34	12	< 0.1%
35	21	< 0.1%
36	22	< 0.1%
37	31	< 0.1%
38	37	< 0.1%
39	74	< 0.1%
40	83	< 0.1%

Value	Count	Frequency (%)
128	2	< 0.1%
126	1	< 0.1%
125	5	< 0.1%
124	4	< 0.1%
123	2	< 0.1%
122	5	< 0.1%
121	6	< 0.1%
120	20	< 0.1%
119	9	< 0.1%
118	22	< 0.1%

temp
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	182
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.98952579

Minimum	0
Maximum	29.7
Zeros	1258
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1.5
Q1	6.8
median	13.1
Q3	18.9
95-th percentile	24.3
Maximum	29.7
Range	29.7
Interquartile range (IQR)	12.1

Descriptive statistics

Standard deviation	7.258684467
Coefficient of variation (CV)	0.5588105821
Kurtosis	-1.111004352
Mean	12.98952579
Median Absolute Deviation (MAD)	6.1
Skewness	0.009899828831
Sum	11985864.1
Variance	52.68850019
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.2	22629	2.5%
3.8	20305	2.2%
17.2	18019	2.0%
10.3	16242	1.8%
18.2	16028	1.7%
3.6	15937	1.7%
5.2	15731	1.7%
9.6	15426	1.7%
18.5	15081	1.6%
1.3	14631	1.6%
Other values (172)	752704	81.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1258	0.1%
0.2	2936	0.3%
0.3	6366	0.7%
0.5	2805	0.3%
0.6	1374	0.1%
0.7	6056	0.7%
0.8	1772	0.2%
0.9	1508	0.2%
1.2	3734	0.4%
1.3	14631	1.6%

Value	Count	Frequency (%)
29.7	1325	0.1%
27.4	5364	0.6%
27.2	5253	0.6%
26.7	4507	0.5%
26.5	5504	0.6%
26.2	3735	0.4%
25.2	3284	0.4%
24.7	8212	0.9%
24.6	4981	0.5%
24.3	7246	0.8%

wind_speed
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	113
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.393785093

Minimum	0
Maximum	28.1
Zeros	6855
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0
5-th percentile	4.2
Q1	5.7
median	7.2
Q3	10
95-th percentile	16.1
Maximum	28.1
Range	28.1
Interquartile range (IQR)	4.3

Descriptive statistics

Standard deviation	4.03346618
Coefficient of variation (CV)	0.480530075
Kurtosis	3.870775129
Mean	8.393785093
Median Absolute Deviation (MAD)	2
Skewness	1.651445675
Sum	7745222.5
Variance	16.26884943
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.5	37221	4.0%
9.7	33247	3.6%
5	28875	3.1%
5.8	27412	3.0%
6.8	23439	2.5%
4.8	22484	2.4%
9	21734	2.4%
5.2	21669	2.3%
6.2	21202	2.3%
6.6	17775	1.9%
Other values (103)	667675	72.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6855	0.7%
3.2	3244	0.4%
3.7	7041	0.8%
3.8	6102	0.7%
3.9	13450	1.5%
4	2584	0.3%
4.1	6312	0.7%
4.2	2196	0.2%
4.3	12505	1.4%
4.4	5870	0.6%

Value	Count	Frequency (%)
28.1	1608	0.2%
27.8	1273	0.1%
26.3	1566	0.2%
25.6	1032	0.1%
25.5	1276	0.1%
24.4	3129	0.3%
23.3	3901	0.4%
21.8	1083	0.1%
21.1	1125	0.1%
19.7	5126	0.6%

wind_direct
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	197
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	198.5998192

Minimum	0
Maximum	359
Zeros	7686
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0
5-th percentile	27
Q1	112
median	211
Q3	278
95-th percentile	343
Maximum	359
Range	359
Interquartile range (IQR)	166

Descriptive statistics

Standard deviation	99.8959487
Coefficient of variation (CV)	0.5030012066
Kurtosis	-0.9810755758
Mean	198.5998192
Median Absolute Deviation (MAD)	78
Skewness	-0.3227512095
Sum	183254607
Variance	9979.200567
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
83	19854	2.2%
278	16226	1.8%
298	15015	1.6%
200	14406	1.6%
246	14302	1.5%
343	13187	1.4%
150	13106	1.4%
201	12854	1.4%
268	12696	1.4%
282	11690	1.3%
Other values (187)	779397	84.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7686	0.8%
1	8178	0.9%
3	3244	0.4%
5	1204	0.1%
7	4981	0.5%
9	5223	0.6%
10	4719	0.5%
12	2268	0.2%
13	1282	0.1%
17	5242	0.6%

Value	Count	Frequency (%)
359	4147	0.4%
358	6881	0.7%
357	1571	0.2%
355	4271	0.5%
354	1644	0.2%
353	1663	0.2%
352	4404	0.5%
351	1864	0.2%
350	7775	0.8%
349	809	0.1%

rain
Real number (ℝ_≥0)

ZEROS

Distinct	70
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.351917185

Minimum	0
Maximum	84.6
Zeros	527342
Zeros (%)	57.2%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1.4
95-th percentile	10.9
Maximum	84.6
Range	84.6
Interquartile range (IQR)	1.4

Descriptive statistics

Standard deviation	7.554861439
Coefficient of variation (CV)	3.212214055
Kurtosis	77.83837016
Mean	2.351917185
Median Absolute Deviation (MAD)	0
Skewness	7.842994869
Sum	2170191.6
Variance	57.07593137
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	527342	57.2%
0.5	26574	2.9%
0.3	24959	2.7%
0.1	19688	2.1%
3.3	16692	1.8%
0.8	16221	1.8%
1.1	14007	1.5%
1	13893	1.5%
7.6	13376	1.4%
2.8	12951	1.4%
Other values (60)	237030	25.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	527342	57.2%
0.1	19688	2.1%
0.2	9914	1.1%
0.3	24959	2.7%
0.4	10206	1.1%
0.5	26574	2.9%
0.6	6553	0.7%
0.7	1311	0.1%
0.8	16221	1.8%
0.9	1537	0.2%

Value	Count	Frequency (%)
84.6	5223	0.6%
24.2	3023	0.3%
23.3	1337	0.1%
22.6	4519	0.5%
21.9	6401	0.7%
19.3	5419	0.6%
18.9	3365	0.4%
18.5	3198	0.3%
18	1523	0.2%
16.1	1882	0.2%

slope_steep
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	60995
Distinct (%)	6.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.254801703

Minimum	0
Maximum	45
Zeros	537702
Zeros (%)	58.3%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	5.970149254
95-th percentile	13.15789474
Maximum	45
Range	45
Interquartile range (IQR)	5.970149254

Descriptive statistics

Standard deviation	5.717967081
Coefficient of variation (CV)	1.756778939
Kurtosis	16.34449373
Mean	3.254801703
Median Absolute Deviation (MAD)	0
Skewness	3.346409872
Sum	3003312.94
Variance	32.69514754
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	537702	58.3%
45	3084	0.3%
6.666666667	1250	0.1%
6.153846154	1230	0.1%
6.472491909	949	0.1%
6.493506494	943	0.1%
6.329113924	935	0.1%
6.309148265	910	0.1%
6.230529595	807	0.1%
6.849315068	790	0.1%
Other values (60985)	374133	40.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	537702	58.3%
0.4178854994	1	< 0.1%
0.4866180049	1	< 0.1%
0.6013229104	1	< 0.1%
0.6040471157	1	< 0.1%
0.641025641	1	< 0.1%
0.6715916723	1	< 0.1%
0.6747638327	1	< 0.1%
0.6752194463	1	< 0.1%
0.705716302	1	< 0.1%

Value	Count	Frequency (%)
45	3084	0.3%
45	1	< 0.1%
44.98977505	1	< 0.1%
44.94382022	2	< 0.1%
44.94382022	2	< 0.1%
44.94382022	6	< 0.1%
44.94382022	1	< 0.1%
44.94382022	2	< 0.1%
44.94382022	1	< 0.1%
44.94382022	1	< 0.1%

slope_ascent
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	71
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.06557129744

Minimum	0
Maximum	10
Zeros	725108
Zeros (%)	78.6%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.4
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.170820599
Coefficient of variation (CV)	2.605112384
Kurtosis	163.7083376
Mean	0.06557129744
Median Absolute Deviation (MAD)	0
Skewness	6.906739497
Sum	60504.8
Variance	0.02917967705
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	725108	78.6%
0.2	88673	9.6%
0.2	51557	5.6%
0.4	21168	2.3%
0.4	8465	0.9%
0.6	7232	0.8%
0.2	3131	0.3%
1	2953	0.3%
0.8	2904	0.3%
0.6	2841	0.3%
Other values (61)	8701	0.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	725108	78.6%
0.2	3131	0.3%
0.2	51557	5.6%
0.2	88673	9.6%
0.2	181	< 0.1%
0.4	84	< 0.1%
0.4	1914	0.2%
0.4	21168	2.3%
0.4	8465	0.9%
0.6	2841	0.3%

Value	Count	Frequency (%)
10	7	< 0.1%
9.2	1	< 0.1%
8.8	1	< 0.1%
8.4	1	< 0.1%
8	1	< 0.1%
7.4	1	< 0.1%
6.8	2	< 0.1%
6.2	1	< 0.1%
5.6	1	< 0.1%
5.4	1	< 0.1%

slope_descent
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	71
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.06401721842

Minimum	0
Maximum	10
Zeros	734893
Zeros (%)	79.6%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.4
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.1710827664
Coefficient of variation (CV)	2.672449236
Kurtosis	83.39894901
Mean	0.06401721842
Median Absolute Deviation (MAD)	0
Skewness	5.798203909
Sum	59070.8
Variance	0.02926931297
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	734893	79.6%
0.2	81790	8.9%
0.2	49297	5.3%
0.4	20802	2.3%
0.4	8395	0.9%
0.6	7163	0.8%
0.6	3176	0.3%
0.8	3019	0.3%
1	3015	0.3%
0.2	2210	0.2%
Other values (61)	8973	1.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	734893	79.6%
0.2	2210	0.2%
0.2	49297	5.3%
0.2	81790	8.9%
0.2	99	< 0.1%
0.4	66	< 0.1%
0.4	1779	0.2%
0.4	20802	2.3%
0.4	8395	0.9%
0.6	3176	0.3%

Value	Count	Frequency (%)
10	1	< 0.1%
8.4	1	< 0.1%
7.8	1	< 0.1%
7.6	1	< 0.1%
6.8	1	< 0.1%
6.6	1	< 0.1%
6.4	1	< 0.1%
6.4	1	< 0.1%
6.2	1	< 0.1%
6.2	1	< 0.1%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	timestamp	heart_rate	enhanced_speed	distance	enhanced_altitude	cadence	temp	wind_speed	wind_direct	rain	slope_steep	slope_descent
0	2022-01-16 06:53:40	80.0	9.1044	10.88	378.4	82.0	0.3	11.2	193.0	0.3	0.000000	0.0
1	2022-01-16 06:53:41	83.0	9.7092	13.57	378.2	83.0	0.3	11.2	193.0	0.3	7.434944	0.2
2	2022-01-16 06:53:42	89.0	9.8748	16.38	378.0	83.0	0.3	11.2	193.0	0.3	7.117438	0.2
3	2022-01-16 06:53:44	93.0	9.4068	21.85	377.8	83.0	0.3	11.2	193.0	0.3	3.656307	0.2
4	2022-01-16 06:53:48	96.0	9.3708	32.38	377.6	82.0	0.3	11.2	193.0	0.3	1.899335	0.2
5	2022-01-16 06:53:50	97.0	9.3708	37.23	377.4	82.0	0.3	11.2	193.0	0.3	4.123711	0.2
6	2022-01-16 06:53:51	97.0	9.3384	39.92	377.4	82.0	0.3	11.2	193.0	0.3	0.000000	0.0
7	2022-01-16 06:53:55	99.0	9.0684	46.59	376.2	63.0	0.3	11.2	193.0	0.3	17.991004	1.2
8	2022-01-16 06:53:56	99.0	8.6004	48.63	375.8	77.0	0.3	11.2	193.0	0.3	19.607843	0.4
9	2022-01-16 06:53:58	102.0	8.0280	53.57	375.4	80.0	0.3	11.2	193.0	0.3	8.097166	0.4

Last rows

	timestamp	heart_rate	enhanced_speed	distance	enhanced_altitude	cadence	temp	wind_speed	wind_direct	slope_steep	slope_ascent
922723	2023-01-16 15:25:12	131.0	12.1608	14904.34	269.4	88.0	3.6	15.3	158.0	5.917160	0.2
922724	2023-01-16 15:25:13	132.0	12.0240	14907.68	269.8	88.0	3.6	15.3	158.0	11.976048	0.4
922725	2023-01-16 15:25:17	134.0	12.1248	14921.10	270.6	88.0	3.6	15.3	158.0	5.961252	0.8
922726	2023-01-16 15:25:19	133.0	12.0600	14927.82	271.0	87.0	3.6	15.3	158.0	5.952381	0.4
922727	2023-01-16 15:25:23	134.0	11.5884	14940.93	271.8	87.0	3.6	15.3	158.0	6.102212	0.8
922728	2023-01-16 15:25:27	135.0	11.8584	14954.00	272.2	87.0	3.6	15.3	158.0	3.060444	0.4
922729	2023-01-16 15:25:32	137.0	11.5560	14970.36	272.8	87.0	3.6	15.3	158.0	3.667482	0.6
922730	2023-01-16 15:25:33	137.0	11.5884	14973.58	272.8	87.0	3.6	15.3	158.0	0.000000	0.0
922731	2023-01-16 15:25:39	139.0	12.0924	14993.47	273.8	87.0	3.6	15.3	158.0	5.027652	1.0
922732	2023-01-16 15:25:45	141.0	10.0440	15011.80	274.6	79.0	3.6	15.3	158.0	4.364430	0.8

Overview

Variables

Interactions

Correlations

Auto

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows